{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["INSTRUCTIONS","Borrower Proforma"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Borrower Proforma","index":1,"n_rows":83,"n_cols":16,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,3,0,12]],"flags":["formulas_cached_only"]}
["blue=calc","black=input",null,"Projected (expected) Revenues & Expenses "]
["Months",0,1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
["# of OD Days per Week",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["# of Patients per OD day",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["# Patients per month",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Average Sale per Patient",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Gross  Sales",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cost of Goods Sold",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gross Profit",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["COGS  (input % amt for COGS)",null,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,{"$error":"#DIV/0!"}]
[]
["Collections (DOS +30 days)",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replace Inventory (30 day terms)",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Cash In (Out)",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Expenses"]
["  Advertising",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Bank and Credit Card Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Business Meals",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Collection Charges",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Continuing Education",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Delivery",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Donations",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Dues and Subscriptions",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Insurance-Compensation",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Insurance-General",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Janitor",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Legal and Accounting",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Office Expense",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Office Salaries",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Payroll Taxes",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Postage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Rent",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Repairs and Maintenance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Taxes and Licenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Telephone",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Uniforms and Laundry",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Utilities",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["  Miscellaneous",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Seller Salary @ $ _____ per diem",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Cash Flow from Operations",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Owner Draw",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cash Flow Avail For Debt Service",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Debt Service 1st Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Excess Cash Flow thru 1st Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Accts Receivable Change",null,0]
["Accts Payable Change",null,0]
["Sum (fund thru working capital)",null,0]
[]
["Monthly Cash (Use) Source",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cum Cash Flow Ops less Debt 1",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Start Cash*",null,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000]
["Cash Avail after Debt 1 Pmt",null,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000]
["*Start cash period 1 is working capital"]
[]
["Other Loan Payments:"]
["2nd Loan ",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Seller 3rd loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Subordinated Debt Pmts",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Monthly Cash (Use) Source",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Start Cash*",null,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000]
["Total End Cash",null,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000]
["Cumulative Cash From Ops less Debt",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["DSC 1st",null,{"$error":"#DIV/0!"}]
["DSC 2nd",null,{"$error":"#DIV/0!"}]
["DSC 3rd",null,{"$error":"#DIV/0!"}]
[]
["Capital Expense"]
["Sales Price",0,null,null,"VOCU Loan",null,0,0.06,"Assumes 120 month amortization"]
["Working  Capital (automatic calc)",15000,null,null,"CASH Equity",null,0]
["Equipment - new",0,null,null,"2nd Loan",null,0]
["Tenant Improvements-new",0,null,null,"3rd Loan-Seller",null,0,0.08,120,"month amortization"]
["SBA Loan fee & Pkg fee",1300,null,null,"Misc (balancing)",null,16300]
["Other  (describe)",0,null,null,"Project Funds Sources",null,16300]
["Total Project Funds Required",16300]